Solved: Datediff between latest date and todays date | 您所在的位置:网站首页 › powerbi datediff › Solved: Datediff between latest date and todays date |
Days Since Latest = DATEDIFF([Latest Date], TODAY(), DAY)
Replace [Latest Date] with the name of the measure you created to find the latest date.
This formula calculates the difference between the latest date and today in days. You can change the last argument in the DATEDIFF function to calculate the difference in a different unit of time, such as weeks or months as per your needs.
Let me know if this works for your scenerio and if you may need further assistance. Did I answer your question? Mark my post as a solution, this will help others!If my response(s) assisted you in any way, don't forget to drop me a "Kudos" Kind Regards,Sahir MaharajData Scientist | Data Engineer | Data Analyst | AI Engineer➤ Website: https://sahirmaharaj.com ➤ Email: [email protected] ➤ Lets connect on LinkedIn: Join my network of 10K+ professionals ➤ Want me to hire me? Lets chat about how I can add value to your business! ➤ Follow me on Medium: Sharing my knowledge about data science, artificial intelligence and tech View solution in original post |
CopyRight 2018-2019 实验室设备网 版权所有 |